2016-07-05 - 24634 - Break Fix - China Customer Statement #CrystalReportsSupport

Break Fix

24634 - Update ZAR_STATEMENTII infoset query

Problem Summary

Need to update the joins between tables in ZAR_STATEMENTII infoset query.

Admin Info

Purpose
 Need to update the joins between tables in ZAR_STATEMENTII infoset Query
Requested by
 Irene Lai
Issue Date
 07/05/2016
Resolved by
 Naveen Gadde
Resolved Date
 07/06/2016
Document Status
 Complete

Detailed Problem Description

Currently the link between KNVV and TVGRT is inner join, due to this the records are getting missed out in the infoset query:
AR Statement.jpg

Solution Analysis and Recommendations

Need to change the links between KNVV and TVGRT to left outer join from KNVV to TVGRT.

Resolution

Changing the link between KNVV and TVGRT to left outer join will fix the issue.

Release Information

2016-07-06 - 24634 - Rel Notes - China Customer Statement